﻿create procedure [dbo].[usp_GetPubHolidays]

@year as datetime

as

select * from TblPublicHolidays where year(HolidayDate)=@year